EMT Practice Test

1. Question Content...

---

Question1: Which of the following would you use to connect to multiple tables in a single data source at once?

Question2: How can you add color to marks in the view in Tableau?

Question3: Which of the following is NOT a new feature introduced in Tableau 2020.1?

Question4: Create a Set containing Customer Names whose Sales are GREATER than 30,000. Which customer had the LEAST sales in this set?

Question5: What does the box in a box plot represent?

Question6: You can create _______________ for members in a dimension so that their labels appear differently in the view.

Question7: _________________ are a local copy of a subset or entire data set that you can use to share data with others, when you need to work offline, and improve performance.

Question8: Which of the following are valid ways to copy a worksheet visualisation as an image?

Question9: Using the dataset, create a bar chart showing the average Quantity broken down by Region, and filtered by Country to only show Japan. What was the average Quantity in the State of Tokyo?

Question10: Using the cwurData table, create a cross-tab showing the number of Publications per Country broken down by Institution, and filtered by Country to only show United Kingdown (UK). For the University of Manchester, what percent of the total publications were contributed in 2014?

Question11: Which of the following 2 columns CANNOT be deleted in Tableau?

Question12: Which one of the following is a dimension?

Question13: When creating a dashboard for multiple devices, which of the following Device options are available in the Device Preview section?

Question14: How can you MANUALLY assign geographic roles to a dimension from the data pane?

Question15: For Bullet Graphs we need at least ____________ measures

Question16: Skipped Join the Geo Data and Time Series Table on the Item Number ID column, and display the Store count for every State on a Map. What was the Store count in 2017 for Texas (TX)?
Join the Geo Data and Time Series Table on the Item Number ID column, and display the Store count for every State on a Map. What was the Store count in 2017 for Texas (TX)?

Question17: Using the dataset provided, create a crosstab showing the Profit of each Region per Year, then add grand totals to the view. What was the total Profit for Canada in 2012 and the total Profit for Canada for 2011 through
2014, respectively?

Question18: Larger image

What is this view referred to as in Tableau?

Question19: Yes or No: The number of marks will increase when you increase the number of Dimensions in a view

Question20: Question 30: Skipped
Using the CoffeeChain table, create a scatter plot of Profit (x-axis) vs Sales (y-axis) broken down by State.
Add a Linear trend line to the view. What is its R-squared value?

Question21: The calculation [Ship Date] - [Order Date] will return _______________

Question22: Which of the following is a good reason for using a bullet graph?

Question23: Which of the following can you add a reference line to?

Question24: ________________ files are shortcuts for quickly connecting to the original data that you use often. Data source files do not contain the actual data but rather the information necessary to connect to the actual data as well as any modifications you've made on top of the actual data such as changing default properties, creating calculated fields, adding groups, and so on.

Question25: Using the Time Series Table, create a Line chart showing the Monthly Year over Year Growth for the Sales, broken down by Assortment. For the Electronics assortment, which Month had the most NEGATIVE value of Year over Year Growth?

Question26: Which of the following is a compelling reason to export a sheet in Tableau to a PDF?

Question27: For a ____________ sort, no matter how the data changes, the values will always stay in the sort order we kept stuff in.

Question28: How do you identify a continuous field in Tableau?

Question29: Which of the following are valid ways of Grouping Data?

Question30: Which of the following is not a Trend Line Model?

Question31: When is an axis created for the visualisation in Tableau?

Question32: What is the one critical difference between normal calculated fields, and the calculated fields created after Data blending?

Question33: Which of the following are valid reasons to use a Tableau Data Extract (.tde) over Live Connections?

Question34: You have cleaned a data source properly, created some calculated fields and renamed some columns. You want to save these changes for future use cases. Which of the following would BEST satisfy this requirement?

Question35: Using the CoffeeChain table, create a chart to see the monthly Percent difference change in Profit, from the beginning of 2012 to the end of 2013. How many months saw a Negative percent difference in Profit?

Question36: Using the CoffeeChain table, create a crosstab showing the Total Expenses per State and add Column Grand Totals to the view. Now group the states of New York, California and Washington. What percent of the total sales does this group contribute?

Question37: Which of the following is a benefit of using a Tableau Data Source (.tds)?

Question38: True or False: Tableau can create worksheet-specific filters

Question39: True or False: It is possible to change the Geographic Role of a dimension

Question40: When you drop a continuous field on Color, Tableau displays a quantitative legend with a ___________ range of colors.

Question41: True or False: Sets can be created on Measures

Question42: Dates in Tableau are typically treated as ______________

Question43: _________________ is useful when you need to change how the data source is configured on a sheet-by-sheet basis, and when you want to combine databases that don't allow relationships or joins

Question44: What is the minimum amount of RAM recommended for any production use of Tableau Server?

Question45: A field that shows average home values for the United States in 2016 is most likely :

Question46: What is the following icon in the Data pane used to do?
Larger image

Question47: True or False: To concatenate fields, they must be of same data type

Question48: Which of the following is the correct way to calculate Profit Ratio in Tableau?

Question49: You want to add Custom shapes to your visualisation. Where can you add these new shapes?

Question50: A ________________ is a single zip file that contains a workbook along with any supporting local file data and background images. This format is the best way to package your work for sharing with others who don't have access to the original data.

Question51: The row and column shelves contain ___________________

Question52: Is it possible to add both a Dashboard and a Worksheet at the same time to a Story Point in Tableau?